Skip to main content

SORT ORDER BY STOPKEY

Short Description

The data is sorted by the column used in the STOPKEY operation. STOPKEYs are used to limit the number of rows returned.

Detailed Description​

The data is sorted by the column used in the STOPKEY operation. STOPKEYs are used to limit the number of rows returned and are seen in queries using the ROWNUM pseudo-column.

e.g.

    SELECT * FROM
    (
      SELECT c1 FROM t1
      ORDER BY c1
    )
    WHERE ROWNUM < 10;

Further Reading​

Search online​

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.